set hive.exec.dynamic.partition=true;            --  动态分区
set hive.exec.dynamic.partition.mode=nonstrict;
set hive.exec.max.dynamic.partitions=90;         --  每天生成 60 个分区
set hive.exec.max.dynamic.partitions.pernode=90; --  每天生成 60 个分区

insert overwrite table jms_dim.dim_lmdm_sys_network_distributi_dt
select
 a.network_id
,a.id
,a.name
,a.code
,a.distribution_type
,a.create_by
,a.update_by
,a.create_by_name
,a.update_by_name
,a.create_time
,a.update_time
,a.p_id
,a.is_default
,b.code as network_code
,b.name as network_name
,'{{ execution_date | cst_ds }}' as dt
from jms_dim.dim_lmdm_sys_network_distributi  as a
left join
jms_dim.dim_network_whole_massage as b
on a.network_id=b.id
 distribute by 1 ;